home *** CD-ROM | disk | FTP | other *** search
/ Microsoft Internet Strate…Tools for the Enterprise / Microsoft Internet Strategy & Tools for the Enterprise.iso / bkoffice / inetsrv.nts / mips / scripts / samples / register.idc < prev    next >
Text File  |  1996-01-10  |  449b  |  16 lines
  1. Datasource: Web SQL
  2. Username: sa
  3. Template: register.htx
  4. RequiredParameters: FirstName, LastName
  5. SQLStatement:
  6. + if exists (
  7. +    select * from Guests 
  8. +    where FirstName='%FirstName%' and LastName='%LastName%'
  9. +    )
  10. +      select result='duplicate'
  11. +else
  12. +  INSERT INTO Guests
  13. +  (FirstName, LastName, Email, Homepage, Comment, WebUse)
  14. +  VALUES('%FirstName%', '%LastName%', '%Email%', '%Homepage%', 
  15. +   '%Comment%', '%WebUse%');
  16.